Overview
Brought to you by YData
Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 377185 |
| Missing cells | 1869153 |
| Missing cells (%) | 27.5% |
| Duplicate rows | 49 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 51.8 MiB |
| Average record size in memory | 144.0 B |
Variable types
| Text | 15 |
|---|---|
| Boolean | 2 |
| Categorical | 1 |
private pool has constant value "True" | Constant |
PrivatePool has constant value "True" | Constant |
| Dataset has 49 (< 0.1%) duplicate rows | Duplicates |
status has 39918 (10.6%) missing values | Missing |
private pool has 373004 (98.9%) missing values | Missing |
propertyType has 34733 (9.2%) missing values | Missing |
baths has 106338 (28.2%) missing values | Missing |
fireplace has 274071 (72.7%) missing values | Missing |
sqft has 40577 (10.8%) missing values | Missing |
beds has 91282 (24.2%) missing values | Missing |
stories has 150716 (40.0%) missing values | Missing |
mls-id has 352243 (93.4%) missing values | Missing |
PrivatePool has 336874 (89.3%) missing values | Missing |
MlsId has 66880 (17.7%) missing values | Missing |
Reproduction
| Analysis started | 2024-11-26 09:56:20.878083 |
|---|---|
| Analysis finished | 2024-11-26 09:57:44.117908 |
| Duration | 1 minute and 23.24 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
status
Text
Missing 
| Distinct | 159 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 39918 |
| Missing (%) | 10.6% |
| Memory size | 2.9 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 8 |
| Mean length | 7.8409183 |
| Min length | 1 |
Unique
| Unique | 38 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Active |
|---|---|
| 2nd row | for sale |
| 3rd row | for sale |
| 4th row | for sale |
| 5th row | for sale |
| Value | Count | Frequency (%) |
| for | 199983 | |
| sale | 199634 | |
| active | 106540 | |
| foreclosure | 6771 | 1.2% |
| new | 6165 | 1.1% |
| construction | 5475 | 1.0% |
| pending | 5364 | 1.0% |
| contract | 3802 | 0.7% |
| pre-foreclosure | 3679 | 0.7% |
| under | 3661 | 0.7% |
| Other values (125) | 17013 | 3.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 351490 | |
| o | 244796 | |
| r | 239503 | |
| 223406 | ||
| s | 217112 | |
| l | 211183 | |
| a | 207546 | |
| f | 166776 | 6.3% |
| c | 137402 | 5.2% |
| t | 132032 | 5.0% |
| Other values (52) | 513237 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2230711 | |
| Space Separator | 223406 | 8.4% |
| Uppercase Letter | 183616 | 6.9% |
| Dash Punctuation | 3764 | 0.1% |
| Other Punctuation | 2762 | 0.1% |
| Decimal Number | 203 | < 0.1% |
| Open Punctuation | 7 | < 0.1% |
| Close Punctuation | 7 | < 0.1% |
| Math Symbol | 5 | < 0.1% |
| Currency Symbol | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 351490 | |
| o | 244796 | |
| r | 239503 | |
| s | 217112 | |
| l | 211183 | |
| a | 207546 | |
| f | 166776 | |
| c | 137402 | 6.2% |
| t | 132032 | 5.9% |
| i | 124434 | 5.6% |
| Other values (14) | 198437 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 107839 | |
| F | 44536 | |
| P | 11133 | 6.1% |
| N | 6212 | 3.4% |
| C | 5915 | 3.2% |
| U | 3674 | 2.0% |
| S | 2412 | 1.3% |
| B | 539 | 0.3% |
| T | 311 | 0.2% |
| I | 302 | 0.2% |
| Other values (8) | 743 | 0.4% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 44 | |
| 1 | 38 | |
| 3 | 19 | |
| 9 | 18 | |
| 0 | 18 | |
| 4 | 18 | |
| 8 | 13 | 6.4% |
| 5 | 13 | 6.4% |
| 7 | 11 | 5.4% |
| 6 | 11 | 5.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2535 | |
| . | 112 | 4.1% |
| : | 112 | 4.1% |
| , | 3 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 223406 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3764 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 7 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 7 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 5 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2414327 | |
| Common | 230156 | 8.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 351490 | |
| o | 244796 | |
| r | 239503 | |
| s | 217112 | |
| l | 211183 | |
| a | 207546 | |
| f | 166776 | |
| c | 137402 | 5.7% |
| t | 132032 | 5.5% |
| i | 124434 | 5.2% |
| Other values (32) | 382053 |
Common
| Value | Count | Frequency (%) |
| 223406 | ||
| - | 3764 | 1.6% |
| / | 2535 | 1.1% |
| . | 112 | < 0.1% |
| : | 112 | < 0.1% |
| 2 | 44 | < 0.1% |
| 1 | 38 | < 0.1% |
| 3 | 19 | < 0.1% |
| 9 | 18 | < 0.1% |
| 0 | 18 | < 0.1% |
| Other values (10) | 90 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2644483 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 351490 | |
| o | 244796 | |
| r | 239503 | |
| 223406 | ||
| s | 217112 | |
| l | 211183 | |
| a | 207546 | |
| f | 166776 | 6.3% |
| c | 137402 | 5.2% |
| t | 132032 | 5.0% |
| Other values (52) | 513237 |
private pool
Boolean
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 373004 |
| Missing (%) | 98.9% |
| Memory size | 736.8 KiB |
| True | 4181 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 4181 | 1.1% |
| (Missing) | 373004 |
propertyType
Text
Missing 
| Distinct | 1280 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 34733 |
| Missing (%) | 9.2% |
| Memory size | 2.9 MiB |
Length
| Max length | 129 |
|---|---|
| Median length | 112 |
| Mean length | 13.522067 |
| Min length | 1 |
Unique
| Unique | 615 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Single Family Home |
|---|---|
| 2nd row | single-family home |
| 3rd row | single-family home |
| 4th row | single-family home |
| 5th row | lot/land |
| Value | Count | Frequency (%) |
| home | 126898 | |
| single | 98013 | |
| family | 97391 | |
| single-family | 92206 | |
| condo | 42532 | 7.0% |
| lot/land | 20552 | 3.4% |
| townhouse | 18579 | 3.1% |
| land | 10939 | 1.8% |
| traditional | 9679 | 1.6% |
| multi-family | 9424 | 1.6% |
| Other values (277) | 79448 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 465212 | 10.0% |
| i | 441168 | 9.5% |
| e | 398458 | 8.6% |
| o | 376556 | 8.1% |
| m | 361450 | 7.8% |
| n | 336503 | 7.3% |
| a | 283147 | 6.1% |
| 263457 | 5.7% | |
| y | 210598 | 4.5% |
| g | 193479 | 4.2% |
| Other values (58) | 1300631 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 3804148 | |
| Uppercase Letter | 383104 | 8.3% |
| Space Separator | 263457 | 5.7% |
| Dash Punctuation | 110549 | 2.4% |
| Other Punctuation | 62907 | 1.4% |
| Decimal Number | 4641 | 0.1% |
| Open Punctuation | 805 | < 0.1% |
| Close Punctuation | 805 | < 0.1% |
| Math Symbol | 243 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 107851 | |
| F | 100978 | |
| H | 44930 | |
| C | 41930 | 10.9% |
| T | 27723 | 7.2% |
| R | 13823 | 3.6% |
| L | 12233 | 3.2% |
| M | 12047 | 3.1% |
| O | 11386 | 3.0% |
| D | 6101 | 1.6% |
| Other values (15) | 4102 | 1.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 465212 | |
| i | 441168 | |
| e | 398458 | |
| o | 376556 | |
| m | 361450 | |
| n | 336503 | |
| a | 283147 | |
| y | 210598 | 5.5% |
| g | 193479 | 5.1% |
| h | 133059 | 3.5% |
| Other values (14) | 604518 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2284 | |
| 2 | 2027 | |
| 3 | 161 | 3.5% |
| 4 | 85 | 1.8% |
| 8 | 38 | 0.8% |
| 7 | 15 | 0.3% |
| 0 | 14 | 0.3% |
| 5 | 11 | 0.2% |
| 9 | 6 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 51353 | |
| , | 11522 | 18.3% |
| & | 31 | < 0.1% |
| . | 1 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 148 | |
| < | 95 |
Space Separator
| Value | Count | Frequency (%) |
| 263457 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 110549 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 805 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 805 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4187252 | |
| Common | 443407 | 9.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 465212 | |
| i | 441168 | |
| e | 398458 | |
| o | 376556 | 9.0% |
| m | 361450 | 8.6% |
| n | 336503 | 8.0% |
| a | 283147 | 6.8% |
| y | 210598 | 5.0% |
| g | 193479 | 4.6% |
| h | 133059 | 3.2% |
| Other values (39) | 987622 |
Common
| Value | Count | Frequency (%) |
| 263457 | ||
| - | 110549 | |
| / | 51353 | 11.6% |
| , | 11522 | 2.6% |
| 1 | 2284 | 0.5% |
| 2 | 2027 | 0.5% |
| ( | 805 | 0.2% |
| ) | 805 | 0.2% |
| 3 | 161 | < 0.1% |
| + | 148 | < 0.1% |
| Other values (9) | 296 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4630659 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 465212 | 10.0% |
| i | 441168 | 9.5% |
| e | 398458 | 8.6% |
| o | 376556 | 8.1% |
| m | 361450 | 7.8% |
| n | 336503 | 7.3% |
| a | 283147 | 6.1% |
| 263457 | 5.7% | |
| y | 210598 | 4.5% |
| g | 193479 | 4.2% |
| Other values (58) | 1300631 |
street
Text
| Distinct | 337076 |
|---|---|
| Distinct (%) | 89.4% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 2.9 MiB |
Length
| Max length | 96 |
|---|---|
| Median length | 83 |
| Mean length | 18.581755 |
| Min length | 1 |
Unique
| Unique | 302913 ? |
|---|---|
| Unique (%) | 80.3% |
Sample
| 1st row | 240 Heather Ln |
|---|---|
| 2nd row | 12911 E Heroy Ave |
| 3rd row | 2005 Westridge Rd |
| 4th row | 4311 Livingston Ave |
| 5th row | 1524 Kiscoe St |
| Value | Count | Frequency (%) |
| st | 83457 | 5.7% |
| dr | 64519 | 4.4% |
| ave | 62480 | 4.2% |
| rd | 32631 | 2.2% |
| ln | 23003 | 1.6% |
| n | 18922 | 1.3% |
| w | 18434 | 1.3% |
| ct | 17819 | 1.2% |
| s | 17722 | 1.2% |
| sw | 15625 | 1.1% |
| Other values (69379) | 1116671 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1155250 | 16.5% | |
| e | 358127 | 5.1% |
| 1 | 338548 | 4.8% |
| r | 287515 | 4.1% |
| t | 285628 | 4.1% |
| a | 269227 | 3.8% |
| n | 248642 | 3.5% |
| 0 | 232055 | 3.3% |
| 2 | 222173 | 3.2% |
| l | 209098 | 3.0% |
| Other values (77) | 3402459 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2965336 | |
| Decimal Number | 1725342 | |
| Space Separator | 1155250 | 16.5% |
| Uppercase Letter | 1085502 | 15.5% |
| Other Punctuation | 70763 | 1.0% |
| Dash Punctuation | 5110 | 0.1% |
| Close Punctuation | 669 | < 0.1% |
| Open Punctuation | 666 | < 0.1% |
| Math Symbol | 73 | < 0.1% |
| Currency Symbol | 7 | < 0.1% |
| Other values (2) | 4 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 358127 | |
| r | 287515 | |
| t | 285628 | |
| a | 269227 | |
| n | 248642 | 8.4% |
| l | 209098 | 7.1% |
| o | 197816 | 6.7% |
| i | 188590 | 6.4% |
| d | 153033 | 5.2% |
| s | 124868 | 4.2% |
| Other values (16) | 642792 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 168200 | |
| A | 103962 | 9.6% |
| D | 83434 | 7.7% |
| C | 80923 | 7.5% |
| W | 79967 | 7.4% |
| R | 62074 | 5.7% |
| P | 61992 | 5.7% |
| N | 58841 | 5.4% |
| L | 58075 | 5.4% |
| B | 57938 | 5.3% |
| Other values (16) | 270096 |
Other Punctuation
| Value | Count | Frequency (%) |
| # | 58707 | |
| : | 8052 | 11.4% |
| . | 1285 | 1.8% |
| , | 1132 | 1.6% |
| / | 829 | 1.2% |
| & | 549 | 0.8% |
| ' | 164 | 0.2% |
| @ | 17 | < 0.1% |
| " | 12 | < 0.1% |
| * | 8 | < 0.1% |
| Other values (3) | 8 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 338548 | |
| 0 | 232055 | |
| 2 | 222173 | |
| 3 | 178043 | |
| 5 | 155114 | |
| 4 | 154559 | |
| 6 | 121592 | 7.0% |
| 7 | 114561 | 6.6% |
| 8 | 109059 | 6.3% |
| 9 | 99638 | 5.8% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 33 | |
| + | 33 | |
| ~ | 4 | 5.5% |
| > | 2 | 2.7% |
| < | 1 | 1.4% |
Space Separator
| Value | Count | Frequency (%) |
| 1155250 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5110 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 669 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 666 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 7 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 3 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4050838 | |
| Common | 2957884 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 358127 | 8.8% |
| r | 287515 | 7.1% |
| t | 285628 | 7.1% |
| a | 269227 | 6.6% |
| n | 248642 | 6.1% |
| l | 209098 | 5.2% |
| o | 197816 | 4.9% |
| i | 188590 | 4.7% |
| S | 168200 | 4.2% |
| d | 153033 | 3.8% |
| Other values (42) | 1684962 |
Common
| Value | Count | Frequency (%) |
| 1155250 | ||
| 1 | 338548 | 11.4% |
| 0 | 232055 | 7.8% |
| 2 | 222173 | 7.5% |
| 3 | 178043 | 6.0% |
| 5 | 155114 | 5.2% |
| 4 | 154559 | 5.2% |
| 6 | 121592 | 4.1% |
| 7 | 114561 | 3.9% |
| 8 | 109059 | 3.7% |
| Other values (25) | 176930 | 6.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7008722 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1155250 | 16.5% | |
| e | 358127 | 5.1% |
| 1 | 338548 | 4.8% |
| r | 287515 | 4.1% |
| t | 285628 | 4.1% |
| a | 269227 | 3.8% |
| n | 248642 | 3.5% |
| 0 | 232055 | 3.3% |
| 2 | 222173 | 3.2% |
| l | 209098 | 3.0% |
| Other values (77) | 3402459 |
baths
Text
Missing 
| Distinct | 229 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 106338 |
| Missing (%) | 28.2% |
| Memory size | 2.9 MiB |
Length
| Max length | 21 |
|---|---|
| Median length | 19 |
| Mean length | 5.4117048 |
| Min length | 1 |
Unique
| Unique | 49 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 3.5 |
|---|---|
| 2nd row | 3 Baths |
| 3rd row | 2 Baths |
| 4th row | 8 Baths |
| 5th row | 2 |
| Value | Count | Frequency (%) |
| baths | 121289 | |
| 2 | 85147 | |
| 3 | 54127 | |
| bathrooms | 23281 | 5.5% |
| 4 | 21450 | 5.1% |
| 2.0 | 16576 | 3.9% |
| 2.5 | 12892 | 3.1% |
| 3.0 | 10869 | 2.6% |
| 1 | 10579 | 2.5% |
| 5 | 7666 | 1.8% |
| Other values (128) | 58522 |
Most occurring characters
| Value | Count | Frequency (%) |
| 151753 | ||
| a | 151195 | |
| t | 144772 | |
| s | 144570 | |
| h | 144570 | |
| B | 144054 | |
| 2 | 122744 | |
| 0 | 74485 | 5.1% |
| 3 | 72973 | 5.0% |
| . | 64765 | 4.4% |
| Other values (25) | 249863 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 685579 | |
| Decimal Number | 378683 | |
| Space Separator | 151753 | 10.4% |
| Uppercase Letter | 144460 | 9.9% |
| Other Punctuation | 102517 | 7.0% |
| Math Symbol | 1716 | 0.1% |
| Dash Punctuation | 1036 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 151195 | |
| t | 144772 | |
| s | 144570 | |
| h | 144570 | |
| o | 46563 | 6.8% |
| m | 23282 | 3.4% |
| r | 23281 | 3.4% |
| b | 7141 | 1.0% |
| q | 202 | < 0.1% |
| e | 1 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 122744 | |
| 0 | 74485 | |
| 3 | 72973 | |
| 5 | 42488 | 11.2% |
| 4 | 27979 | 7.4% |
| 1 | 26418 | 7.0% |
| 7 | 5244 | 1.4% |
| 6 | 4567 | 1.2% |
| 8 | 1227 | 0.3% |
| 9 | 558 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 144054 | |
| S | 203 | 0.1% |
| F | 202 | 0.1% |
| M | 1 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 64765 | |
| : | 23281 | 22.7% |
| , | 14394 | 14.0% |
| / | 77 | 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1030 | |
| — | 6 | 0.6% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 934 | |
| ~ | 782 |
Space Separator
| Value | Count | Frequency (%) |
| 151753 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 830039 | |
| Common | 635705 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 151753 | ||
| 2 | 122744 | |
| 0 | 74485 | |
| 3 | 72973 | |
| . | 64765 | |
| 5 | 42488 | 6.7% |
| 4 | 27979 | 4.4% |
| 1 | 26418 | 4.2% |
| : | 23281 | 3.7% |
| , | 14394 | 2.3% |
| Other values (9) | 14425 | 2.3% |
Latin
| Value | Count | Frequency (%) |
| a | 151195 | |
| t | 144772 | |
| s | 144570 | |
| h | 144570 | |
| B | 144054 | |
| o | 46563 | 5.6% |
| m | 23282 | 2.8% |
| r | 23281 | 2.8% |
| b | 7141 | 0.9% |
| S | 203 | < 0.1% |
| Other values (6) | 408 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1465738 | |
| Punctuation | 6 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 151753 | ||
| a | 151195 | |
| t | 144772 | |
| s | 144570 | |
| h | 144570 | |
| B | 144054 | |
| 2 | 122744 | |
| 0 | 74485 | 5.1% |
| 3 | 72973 | 5.0% |
| . | 64765 | 4.4% |
| Other values (24) | 249857 |
Punctuation
| Value | Count | Frequency (%) |
| — | 6 |
homeFacts
Text
| Distinct | 321009 |
|---|---|
| Distinct (%) | 85.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 840 |
|---|---|
| Median length | 605 |
| Mean length | 374.50896 |
| Min length | 334 |
Unique
| Unique | 311038 ? |
|---|---|
| Unique (%) | 82.5% |
Sample
| 1st row | {'atAGlanceFacts': [{'factValue': '2019', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': 'Central A/C, Heat Pump', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': None, 'factLabel': 'lotsize'}, {'factValue': '$144', 'factLabel': 'Price/sqft'}]} |
|---|---|
| 2nd row | {'atAGlanceFacts': [{'factValue': '2019', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '5828 sqft', 'factLabel': 'lotsize'}, {'factValue': '$159/sqft', 'factLabel': 'Price/sqft'}]} |
| 3rd row | {'atAGlanceFacts': [{'factValue': '1961', 'factLabel': 'Year built'}, {'factValue': '1967', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced Air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'Attached Garage', 'factLabel': 'Parking'}, {'factValue': '8,626 sqft', 'factLabel': 'lotsize'}, {'factValue': '$965/sqft', 'factLabel': 'Price/sqft'}]} |
| 4th row | {'atAGlanceFacts': [{'factValue': '2006', 'factLabel': 'Year built'}, {'factValue': '2006', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced Air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'Detached Garage', 'factLabel': 'Parking'}, {'factValue': '8,220 sqft', 'factLabel': 'lotsize'}, {'factValue': '$371/sqft', 'factLabel': 'Price/sqft'}]} |
| 5th row | {'atAGlanceFacts': [{'factValue': '', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '10,019 sqft', 'factLabel': 'lotsize'}, {'factValue': None, 'factLabel': 'Price/sqft'}]} |
| Value | Count | Frequency (%) |
| factlabel | 2640295 | |
| factvalue | 2640295 | |
| 757424 | 5.9% | |
| year | 754370 | 5.9% |
| cooling | 390962 | 3.1% |
| heating | 389267 | 3.1% |
| parking | 383675 | 3.0% |
| price/sqft | 377185 | 3.0% |
| lotsize | 377185 | 3.0% |
| ataglancefacts | 377185 | 3.0% |
| Other values (29472) | 3668656 |
Most occurring characters
| Value | Count | Frequency (%) |
| ' | 21620955 | |
| a | 14183171 | 10.0% |
| 12379318 | 8.8% | |
| e | 9771911 | 6.9% |
| t | 8594876 | 6.1% |
| l | 7533640 | 5.3% |
| c | 6890716 | 4.9% |
| f | 5960366 | 4.2% |
| : | 5657791 | 4.0% |
| , | 5126864 | 3.6% |
| Other values (76) | 43539555 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 74422172 | |
| Other Punctuation | 33220252 | |
| Space Separator | 12379318 | 8.8% |
| Uppercase Letter | 10165905 | 7.2% |
| Decimal Number | 3896951 | 2.8% |
| Close Punctuation | 3409932 | 2.4% |
| Open Punctuation | 3409932 | 2.4% |
| Currency Symbol | 311248 | 0.2% |
| Dash Punctuation | 42947 | < 0.1% |
| Math Symbol | 505 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 14183171 | |
| e | 9771911 | |
| t | 8594876 | |
| l | 7533640 | |
| c | 6890716 | |
| f | 5960366 | |
| u | 3047834 | 4.1% |
| b | 3024601 | 4.1% |
| i | 2569220 | 3.5% |
| r | 2434890 | 3.3% |
| Other values (16) | 10410947 |
Uppercase Letter
| Value | Count | Frequency (%) |
| V | 2642336 | |
| L | 2642024 | |
| P | 774976 | 7.6% |
| C | 671964 | 6.6% |
| A | 608724 | 6.0% |
| F | 608256 | 6.0% |
| G | 515037 | 5.1% |
| H | 436687 | 4.3% |
| R | 388024 | 3.8% |
| Y | 378210 | 3.7% |
| Other values (16) | 499667 | 4.9% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 758148 | |
| 0 | 606701 | |
| 9 | 559266 | |
| 2 | 486731 | |
| 5 | 270373 | 6.9% |
| 8 | 253021 | 6.5% |
| 7 | 247241 | 6.3% |
| 6 | 245449 | 6.3% |
| 4 | 235728 | 6.0% |
| 3 | 234293 | 6.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 21620955 | |
| : | 5657791 | 17.0% |
| , | 5126864 | 15.4% |
| / | 582199 | 1.8% |
| . | 231556 | 0.7% |
| " | 668 | < 0.1% |
| % | 176 | < 0.1% |
| & | 42 | < 0.1% |
| ; | 1 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| + | 494 | |
| > | 5 | 1.0% |
| ~ | 4 | 0.8% |
| < | 2 | 0.4% |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 3017480 | |
| ] | 377185 | 11.1% |
| ) | 15267 | 0.4% |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 3017480 | |
| [ | 377185 | 11.1% |
| ( | 15267 | 0.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| — | 25251 | |
| - | 17696 |
Space Separator
| Value | Count | Frequency (%) |
| 12379318 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 311248 |
Other Symbol
| Value | Count | Frequency (%) |
| ® | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 84588077 | |
| Common | 56671086 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 14183171 | |
| e | 9771911 | |
| t | 8594876 | |
| l | 7533640 | 8.9% |
| c | 6890716 | 8.1% |
| f | 5960366 | 7.0% |
| u | 3047834 | 3.6% |
| b | 3024601 | 3.6% |
| V | 2642336 | 3.1% |
| L | 2642024 | 3.1% |
| Other values (42) | 20296602 |
Common
| Value | Count | Frequency (%) |
| ' | 21620955 | |
| 12379318 | ||
| : | 5657791 | 10.0% |
| , | 5126864 | 9.0% |
| } | 3017480 | 5.3% |
| { | 3017480 | 5.3% |
| 1 | 758148 | 1.3% |
| 0 | 606701 | 1.1% |
| / | 582199 | 1.0% |
| 9 | 559266 | 1.0% |
| Other values (24) | 3344884 | 5.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141233910 | |
| Punctuation | 25251 | < 0.1% |
| None | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| ' | 21620955 | |
| a | 14183171 | 10.0% |
| 12379318 | 8.8% | |
| e | 9771911 | 6.9% |
| t | 8594876 | 6.1% |
| l | 7533640 | 5.3% |
| c | 6890716 | 4.9% |
| f | 5960366 | 4.2% |
| : | 5657791 | 4.0% |
| , | 5126864 | 3.6% |
| Other values (73) | 43514302 |
Punctuation
| Value | Count | Frequency (%) |
| — | 25251 |
None
| Value | Count | Frequency (%) |
| Â | 1 | |
| ® | 1 |
fireplace
Text
Missing 
| Distinct | 1652 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 274071 |
| Missing (%) | 72.7% |
| Memory size | 2.9 MiB |
Length
| Max length | 231 |
|---|---|
| Median length | 3 |
| Mean length | 5.0304614 |
| Min length | 1 |
Unique
| Unique | 1038 ? |
|---|---|
| Unique (%) | 1.0% |
Sample
| 1st row | Gas Logs |
|---|---|
| 2nd row | yes |
| 3rd row | yes |
| 4th row | yes |
| 5th row | Yes |
| Value | Count | Frequency (%) |
| yes | 71212 | |
| 1 | 15304 | 11.5% |
| room | 3325 | 2.5% |
| fireplace | 3304 | 2.5% |
| gas | 3127 | 2.4% |
| 2 | 2535 | 1.9% |
| not | 1993 | 1.5% |
| applicable | 1993 | 1.5% |
| closets | 1725 | 1.3% |
| wood | 1710 | 1.3% |
| Other values (350) | 26724 | 20.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 93119 | |
| s | 81955 | |
| y | 52257 | 10.1% |
| 29838 | 5.8% | |
| Y | 21802 | 4.2% |
| o | 21186 | 4.1% |
| i | 18735 | 3.6% |
| a | 18442 | 3.6% |
| 1 | 15315 | 3.0% |
| l | 15193 | 2.9% |
| Other values (59) | 150869 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 382475 | |
| Uppercase Letter | 74561 | 14.4% |
| Space Separator | 29838 | 5.8% |
| Decimal Number | 19072 | 3.7% |
| Other Punctuation | 10723 | 2.1% |
| Dash Punctuation | 1841 | 0.4% |
| Math Symbol | 71 | < 0.1% |
| Open Punctuation | 65 | < 0.1% |
| Close Punctuation | 65 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 93119 | |
| s | 81955 | |
| y | 52257 | |
| o | 21186 | 5.5% |
| i | 18735 | 4.9% |
| a | 18442 | 4.8% |
| l | 15193 | 4.0% |
| n | 14008 | 3.7% |
| r | 12572 | 3.3% |
| t | 12141 | 3.2% |
| Other values (15) | 42867 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Y | 21802 | |
| F | 8260 | 11.1% |
| L | 5104 | 6.8% |
| G | 4755 | 6.4% |
| R | 4675 | 6.3% |
| C | 4488 | 6.0% |
| A | 3580 | 4.8% |
| W | 3439 | 4.6% |
| N | 3362 | 4.5% |
| I | 3250 | 4.4% |
| Other values (14) | 11846 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 15315 | |
| 2 | 2537 | 13.3% |
| 3 | 619 | 3.2% |
| 0 | 277 | 1.5% |
| 4 | 198 | 1.0% |
| 5 | 65 | 0.3% |
| 6 | 35 | 0.2% |
| 7 | 18 | 0.1% |
| 8 | 5 | < 0.1% |
| 9 | 3 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 9818 | |
| / | 734 | 6.8% |
| # | 167 | 1.6% |
| . | 3 | < 0.1% |
| : | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 29838 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1841 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 71 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 65 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 65 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 457036 | |
| Common | 61675 | 11.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 93119 | |
| s | 81955 | |
| y | 52257 | |
| Y | 21802 | 4.8% |
| o | 21186 | 4.6% |
| i | 18735 | 4.1% |
| a | 18442 | 4.0% |
| l | 15193 | 3.3% |
| n | 14008 | 3.1% |
| r | 12572 | 2.8% |
| Other values (39) | 107767 |
Common
| Value | Count | Frequency (%) |
| 29838 | ||
| 1 | 15315 | |
| , | 9818 | 15.9% |
| 2 | 2537 | 4.1% |
| - | 1841 | 3.0% |
| / | 734 | 1.2% |
| 3 | 619 | 1.0% |
| 0 | 277 | 0.4% |
| 4 | 198 | 0.3% |
| # | 167 | 0.3% |
| Other values (10) | 331 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 518711 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 93119 | |
| s | 81955 | |
| y | 52257 | 10.1% |
| 29838 | 5.8% | |
| Y | 21802 | 4.2% |
| o | 21186 | 4.1% |
| i | 18735 | 3.6% |
| a | 18442 | 3.6% |
| 1 | 15315 | 3.0% |
| l | 15193 | 2.9% |
| Other values (59) | 150869 |
city
Text
| Distinct | 2026 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 34 |
| Missing (%) | < 0.1% |
| Memory size | 2.9 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 29 |
| Mean length | 8.9985735 |
| Min length | 1 |
Unique
| Unique | 435 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Southern Pines |
|---|---|
| 2nd row | Spokane Valley |
| 3rd row | Los Angeles |
| 4th row | Dallas |
| 5th row | Palm Bay |
| Value | Count | Frequency (%) |
| houston | 24460 | 4.8% |
| miami | 20776 | 4.1% |
| san | 19402 | 3.8% |
| antonio | 15592 | 3.1% |
| fort | 11470 | 2.3% |
| jacksonville | 10375 | 2.1% |
| charlotte | 9694 | 1.9% |
| dallas | 8858 | 1.8% |
| beach | 8785 | 1.7% |
| brooklyn | 7298 | 1.4% |
| Other values (1701) | 367717 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 343158 | 10.1% |
| o | 283839 | 8.4% |
| n | 257160 | 7.6% |
| e | 248081 | 7.3% |
| l | 224356 | 6.6% |
| i | 219089 | 6.5% |
| t | 194518 | 5.7% |
| s | 159791 | 4.7% |
| r | 151339 | 4.5% |
| 127326 | 3.8% | |
| Other values (50) | 1185164 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2677503 | |
| Uppercase Letter | 588826 | 17.3% |
| Space Separator | 127326 | 3.8% |
| Other Punctuation | 94 | < 0.1% |
| Dash Punctuation | 64 | < 0.1% |
| Decimal Number | 4 | < 0.1% |
| Open Punctuation | 2 | < 0.1% |
| Close Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 343158 | |
| o | 283839 | |
| n | 257160 | |
| e | 248081 | |
| l | 224356 | |
| i | 219089 | |
| t | 194518 | 7.3% |
| s | 159791 | 6.0% |
| r | 151339 | 5.7% |
| h | 89796 | 3.4% |
| Other values (16) | 506376 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 55874 | 9.5% |
| C | 50725 | 8.6% |
| A | 50275 | 8.5% |
| P | 43885 | 7.5% |
| H | 41896 | 7.1% |
| M | 37157 | 6.3% |
| L | 36547 | 6.2% |
| B | 32977 | 5.6% |
| D | 27228 | 4.6% |
| O | 22869 | 3.9% |
| Other values (15) | 189393 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 91 | |
| ' | 2 | 2.1% |
| / | 1 | 1.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 2 | |
| 0 | 2 |
Space Separator
| Value | Count | Frequency (%) |
| 127326 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 64 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3266329 | |
| Common | 127492 | 3.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 343158 | 10.5% |
| o | 283839 | 8.7% |
| n | 257160 | 7.9% |
| e | 248081 | 7.6% |
| l | 224356 | 6.9% |
| i | 219089 | 6.7% |
| t | 194518 | 6.0% |
| s | 159791 | 4.9% |
| r | 151339 | 4.6% |
| h | 89796 | 2.7% |
| Other values (41) | 1095202 |
Common
| Value | Count | Frequency (%) |
| 127326 | ||
| . | 91 | 0.1% |
| - | 64 | 0.1% |
| 3 | 2 | < 0.1% |
| 0 | 2 | < 0.1% |
| ( | 2 | < 0.1% |
| ) | 2 | < 0.1% |
| ' | 2 | < 0.1% |
| / | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3393821 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 343158 | 10.1% |
| o | 283839 | 8.4% |
| n | 257160 | 7.6% |
| e | 248081 | 7.3% |
| l | 224356 | 6.6% |
| i | 219089 | 6.5% |
| t | 194518 | 5.7% |
| s | 159791 | 4.7% |
| r | 151339 | 4.5% |
| 127326 | 3.8% | |
| Other values (50) | 1185164 |
schools
Text
| Distinct | 297365 |
|---|---|
| Distinct (%) | 78.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 3688 |
|---|---|
| Median length | 3289 |
| Mean length | 301.95763 |
| Min length | 68 |
Unique
| Unique | 265895 ? |
|---|---|
| Unique (%) | 70.5% |
Sample
| 1st row | [{'rating': ['4', '4', '7', 'NR', '4', '7', 'NR', 'NR'], 'data': {'Distance': ['2.7 mi', '3.6 mi', '5.1 mi', '4.0 mi', '10.5 mi', '12.6 mi', '2.7 mi', '3.1 mi'], 'Grades': ['3–5', '6–8', '9–12', 'PK–2', '6–8', '9–12', 'PK–5', 'K–12']}, 'name': ['Southern Pines Elementary School', 'Southern Middle School', 'Pinecrest High School', 'Southern Pines Primary School', "Crain's Creek Middle School", 'Union Pines High School', 'Episcopal Day Private School', 'Calvary Christian Private School']}] |
|---|---|
| 2nd row | [{'rating': ['4/10', 'None/10', '4/10'], 'data': {'Distance': ['1.65mi', '1.32mi', '1.01mi'], 'Grades': ['9-12', '3-8', 'PK-8']}, 'name': ['East Valley High School&Extension', 'Eastvalley Middle School', 'Trentwood Elementary School']}] |
| 3rd row | [{'rating': ['8/10', '4/10', '8/10'], 'data': {'Distance': ['1.19mi', '2.06mi', '2.63mi'], 'Grades': ['6-8', 'K-5', '9-12']}, 'name': ['Paul Revere Middle School', 'Brentwood Science School', 'Palisades Charter High School']}] |
| 4th row | [{'rating': ['9/10', '9/10', '10/10', '9/10'], 'data': {'Distance': ['1.05mi', '0.1mi', '1.05mi', '0.81mi'], 'Grades': ['5-6', 'PK-4', '7-8', '9-12']}, 'name': ['Mcculloch Intermediate School', 'Bradfield Elementary School', 'Highland Park Middle School', 'Highland Park High School']}] |
| 5th row | [{'rating': ['4/10', '5/10', '5/10'], 'data': {'Distance': ['5.96mi', '3.25mi', '3.03mi'], 'Grades': ['7-8', '9-12', 'PK-6']}, 'name': ['Southwest Middle School', 'Bayside High School', 'Westside Elementary School']}] |
| Value | Count | Frequency (%) |
| school | 1414258 | 9.8% |
| mi | 906984 | 6.3% |
| elementary | 446657 | 3.1% |
| high | 438612 | 3.0% |
| name | 377355 | 2.6% |
| grades | 377288 | 2.6% |
| rating | 377185 | 2.6% |
| data | 377185 | 2.6% |
| distance | 377185 | 2.6% |
| middle | 322399 | 2.2% |
| Other values (16026) | 9085018 |
Most occurring characters
| Value | Count | Frequency (%) |
| ' | 16750056 | 14.7% |
| 14127354 | 12.4% | |
| , | 6138741 | 5.4% |
| e | 4777468 | 4.2% |
| o | 4683179 | 4.1% |
| a | 4603527 | 4.0% |
| i | 4521043 | 4.0% |
| l | 3313909 | 2.9% |
| t | 3119253 | 2.7% |
| n | 3061675 | 2.7% |
| Other values (74) | 48797683 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 46326910 | |
| Other Punctuation | 27492645 | |
| Space Separator | 14127354 | 12.4% |
| Decimal Number | 10672263 | 9.4% |
| Uppercase Letter | 8555800 | 7.5% |
| Open Punctuation | 2646690 | 2.3% |
| Close Punctuation | 2646689 | 2.3% |
| Dash Punctuation | 1425441 | 1.3% |
| Math Symbol | 96 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4777468 | |
| o | 4683179 | |
| a | 4603527 | |
| i | 4521043 | |
| l | 3313909 | 7.2% |
| t | 3119253 | 6.7% |
| n | 3061675 | 6.6% |
| r | 2990290 | 6.5% |
| m | 2887012 | 6.2% |
| h | 2482228 | 5.4% |
| Other values (17) | 9887326 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1736884 | |
| P | 823370 | |
| K | 700928 | 8.2% |
| H | 627414 | 7.3% |
| M | 588358 | 6.9% |
| E | 573335 | 6.7% |
| D | 489345 | 5.7% |
| G | 481790 | 5.6% |
| C | 418547 | 4.9% |
| A | 318764 | 3.7% |
| Other values (16) | 1797065 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 16750056 | |
| , | 6138741 | 22.3% |
| : | 1887363 | 6.9% |
| . | 1691659 | 6.2% |
| / | 986866 | 3.6% |
| " | 22426 | 0.1% |
| & | 9112 | < 0.1% |
| @ | 5683 | < 0.1% |
| # | 532 | < 0.1% |
| \ | 198 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 2443792 | |
| 0 | 1678654 | |
| 2 | 1271285 | |
| 8 | 942715 | 8.8% |
| 5 | 926544 | 8.7% |
| 6 | 872241 | 8.2% |
| 9 | 788850 | 7.4% |
| 3 | 650120 | 6.1% |
| 4 | 598916 | 5.6% |
| 7 | 499146 | 4.7% |
Close Punctuation
| Value | Count | Frequency (%) |
| ] | 1885925 | |
| } | 754370 | 28.5% |
| ) | 6394 | 0.2% |
Open Punctuation
| Value | Count | Frequency (%) |
| [ | 1885925 | |
| { | 754370 | 28.5% |
| ( | 6395 | 0.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1047339 | |
| – | 378102 | 26.5% |
Space Separator
| Value | Count | Frequency (%) |
| 14127354 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 96 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 59011178 | |
| Latin | 54882710 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4777468 | 8.7% |
| o | 4683179 | 8.5% |
| a | 4603527 | 8.4% |
| i | 4521043 | 8.2% |
| l | 3313909 | 6.0% |
| t | 3119253 | 5.7% |
| n | 3061675 | 5.6% |
| r | 2990290 | 5.4% |
| m | 2887012 | 5.3% |
| h | 2482228 | 4.5% |
| Other values (43) | 18443126 |
Common
| Value | Count | Frequency (%) |
| ' | 16750056 | |
| 14127354 | ||
| , | 6138741 | 10.4% |
| 1 | 2443792 | 4.1% |
| : | 1887363 | 3.2% |
| ] | 1885925 | 3.2% |
| [ | 1885925 | 3.2% |
| . | 1691659 | 2.9% |
| 0 | 1678654 | 2.8% |
| 2 | 1271285 | 2.2% |
| Other values (21) | 9250424 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 113515768 | |
| Punctuation | 378102 | 0.3% |
| None | 18 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| ' | 16750056 | 14.8% |
| 14127354 | 12.4% | |
| , | 6138741 | 5.4% |
| e | 4777468 | 4.2% |
| o | 4683179 | 4.1% |
| a | 4603527 | 4.1% |
| i | 4521043 | 4.0% |
| l | 3313909 | 2.9% |
| t | 3119253 | 2.7% |
| n | 3061675 | 2.7% |
| Other values (72) | 48419563 |
Punctuation
| Value | Count | Frequency (%) |
| – | 378102 |
None
| Value | Count | Frequency (%) |
| é | 18 |
sqft
Text
Missing 
| Distinct | 25405 |
|---|---|
| Distinct (%) | 7.5% |
| Missing | 40577 |
| Missing (%) | 10.8% |
| Memory size | 2.9 MiB |
Length
| Max length | 41 |
|---|---|
| Median length | 40 |
| Mean length | 9.3000196 |
| Min length | 1 |
Unique
| Unique | 7325 ? |
|---|---|
| Unique (%) | 2.2% |
Sample
| 1st row | 2900 |
|---|---|
| 2nd row | 1,947 sqft |
| 3rd row | 3,000 sqft |
| 4th row | 6,457 sqft |
| 5th row | 897 sqft |
| Value | Count | Frequency (%) |
| sqft | 182737 | |
| area | 23678 | 3.9% |
| livable | 23678 | 3.9% |
| interior | 23678 | 3.9% |
| total | 23678 | 3.9% |
| 0 | 11854 | 1.9% |
| 1,200 | 1298 | 0.2% |
| 1,000 | 955 | 0.2% |
| 1,500 | 911 | 0.1% |
| 1,100 | 879 | 0.1% |
| Other values (14448) | 320711 |
Most occurring characters
| Value | Count | Frequency (%) |
| 277449 | 8.9% | |
| , | 253135 | 8.1% |
| 1 | 232504 | 7.4% |
| t | 230093 | 7.4% |
| 2 | 184940 | 5.9% |
| s | 182737 | 5.8% |
| q | 182737 | 5.8% |
| f | 182737 | 5.8% |
| 0 | 170258 | 5.4% |
| 3 | 115328 | 3.7% |
| Other values (18) | 1118543 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1275542 | |
| Decimal Number | 1275338 | |
| Space Separator | 277449 | 8.9% |
| Other Punctuation | 276813 | 8.8% |
| Uppercase Letter | 23678 | 0.8% |
| Dash Punctuation | 1641 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 230093 | |
| s | 182737 | |
| q | 182737 | |
| f | 182737 | |
| a | 94712 | |
| l | 71034 | 5.6% |
| i | 71034 | 5.6% |
| e | 71034 | 5.6% |
| r | 71034 | 5.6% |
| o | 47356 | 3.7% |
| Other values (3) | 71034 | 5.6% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 232504 | |
| 2 | 184940 | |
| 0 | 170258 | |
| 3 | 115328 | |
| 4 | 108611 | |
| 5 | 99097 | |
| 6 | 98967 | |
| 8 | 98184 | |
| 7 | 84992 | 6.7% |
| 9 | 82457 | 6.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 253135 | |
| : | 23678 | 8.6% |
Space Separator
| Value | Count | Frequency (%) |
| 277449 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 23678 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1641 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1831241 | |
| Latin | 1299220 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 277449 | ||
| , | 253135 | |
| 1 | 232504 | |
| 2 | 184940 | |
| 0 | 170258 | |
| 3 | 115328 | |
| 4 | 108611 | 5.9% |
| 5 | 99097 | 5.4% |
| 6 | 98967 | 5.4% |
| 8 | 98184 | 5.4% |
| Other values (4) | 192768 |
Latin
| Value | Count | Frequency (%) |
| t | 230093 | |
| s | 182737 | |
| q | 182737 | |
| f | 182737 | |
| a | 94712 | |
| l | 71034 | 5.5% |
| i | 71034 | 5.5% |
| e | 71034 | 5.5% |
| r | 71034 | 5.5% |
| o | 47356 | 3.6% |
| Other values (4) | 94712 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3130461 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 277449 | 8.9% | |
| , | 253135 | 8.1% |
| 1 | 232504 | 7.4% |
| t | 230093 | 7.4% |
| 2 | 184940 | 5.9% |
| s | 182737 | 5.8% |
| q | 182737 | 5.8% |
| f | 182737 | 5.8% |
| 0 | 170258 | 5.4% |
| 3 | 115328 | 3.7% |
| Other values (18) | 1118543 |
zipcode
Text
| Distinct | 4549 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 4.9980593 |
| Min length | 1 |
Unique
| Unique | 598 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 28387 |
|---|---|
| 2nd row | 99216 |
| 3rd row | 90049 |
| 4th row | 75205 |
| 5th row | 32908 |
| Value | Count | Frequency (%) |
| 32137 | 2141 | 0.6% |
| 33131 | 1563 | 0.4% |
| 34747 | 1488 | 0.4% |
| 78245 | 1390 | 0.4% |
| 34759 | 1333 | 0.4% |
| 33132 | 1328 | 0.4% |
| 33137 | 1308 | 0.3% |
| 78253 | 1282 | 0.3% |
| 78254 | 1238 | 0.3% |
| 33130 | 1170 | 0.3% |
| Other values (4539) | 362944 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 336087 | |
| 1 | 233614 | |
| 2 | 233487 | |
| 7 | 230508 | |
| 0 | 221306 | |
| 4 | 151634 | |
| 8 | 148263 | |
| 9 | 120899 | 6.4% |
| 6 | 105045 | 5.6% |
| 5 | 104106 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1884949 | |
| Dash Punctuation | 244 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 336087 | |
| 1 | 233614 | |
| 2 | 233487 | |
| 7 | 230508 | |
| 0 | 221306 | |
| 4 | 151634 | |
| 8 | 148263 | |
| 9 | 120899 | 6.4% |
| 6 | 105045 | 5.6% |
| 5 | 104106 | 5.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 244 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1885193 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 336087 | |
| 1 | 233614 | |
| 2 | 233487 | |
| 7 | 230508 | |
| 0 | 221306 | |
| 4 | 151634 | |
| 8 | 148263 | |
| 9 | 120899 | 6.4% |
| 6 | 105045 | 5.6% |
| 5 | 104106 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1885193 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 336087 | |
| 1 | 233614 | |
| 2 | 233487 | |
| 7 | 230508 | |
| 0 | 221306 | |
| 4 | 151634 | |
| 8 | 148263 | |
| 9 | 120899 | 6.4% |
| 6 | 105045 | 5.6% |
| 5 | 104106 | 5.5% |
beds
Text
Missing 
| Distinct | 1184 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 91282 |
| Missing (%) | 24.2% |
| Memory size | 2.9 MiB |
Length
| Max length | 122 |
|---|---|
| Median length | 121 |
| Mean length | 4.1196 |
| Min length | 1 |
Unique
| Unique | 715 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 3 Beds |
| 3rd row | 3 Beds |
| 4th row | 5 Beds |
| 5th row | 2 Beds |
| Value | Count | Frequency (%) |
| beds | 133199 | |
| 3 | 97751 | |
| 4 | 63717 | |
| 2 | 47731 | 10.5% |
| bd | 32127 | 7.1% |
| 5 | 20337 | 4.5% |
| baths | 15283 | 3.4% |
| 3.0 | 8088 | 1.8% |
| 6 | 6276 | 1.4% |
| 1 | 5744 | 1.3% |
| Other values (1126) | 23708 | 5.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 168960 | ||
| d | 165341 | |
| s | 151538 | |
| B | 149236 | |
| e | 134898 | |
| 3 | 106736 | |
| 4 | 69967 | |
| 2 | 51383 | 4.4% |
| b | 32131 | 2.7% |
| 5 | 22785 | 1.9% |
| Other values (46) | 124831 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 541541 | |
| Decimal Number | 294668 | |
| Space Separator | 168960 | 14.3% |
| Uppercase Letter | 149291 | 12.7% |
| Other Punctuation | 21120 | 1.8% |
| Dash Punctuation | 2224 | 0.2% |
| Currency Symbol | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 165341 | |
| s | 151538 | |
| e | 134898 | |
| b | 32131 | 5.9% |
| a | 17696 | 3.3% |
| t | 17489 | 3.2% |
| h | 16041 | 3.0% |
| r | 1677 | 0.3% |
| c | 1649 | 0.3% |
| f | 1441 | 0.3% |
| Other values (11) | 1640 | 0.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 149236 | |
| R | 19 | < 0.1% |
| L | 5 | < 0.1% |
| O | 4 | < 0.1% |
| M | 4 | < 0.1% |
| E | 3 | < 0.1% |
| I | 3 | < 0.1% |
| K | 3 | < 0.1% |
| D | 3 | < 0.1% |
| C | 2 | < 0.1% |
| Other values (6) | 9 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 106736 | |
| 4 | 69967 | |
| 2 | 51383 | |
| 5 | 22785 | 7.7% |
| 0 | 22008 | 7.5% |
| 1 | 8319 | 2.8% |
| 6 | 7475 | 2.5% |
| 7 | 2707 | 0.9% |
| 8 | 2019 | 0.7% |
| 9 | 1269 | 0.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 19750 | |
| , | 1359 | 6.4% |
| ' | 4 | < 0.1% |
| / | 4 | < 0.1% |
| % | 2 | < 0.1% |
| # | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 168960 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2224 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 690832 | |
| Common | 486974 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| d | 165341 | |
| s | 151538 | |
| B | 149236 | |
| e | 134898 | |
| b | 32131 | 4.7% |
| a | 17696 | 2.6% |
| t | 17489 | 2.5% |
| h | 16041 | 2.3% |
| r | 1677 | 0.2% |
| c | 1649 | 0.2% |
| Other values (27) | 3136 | 0.5% |
Common
| Value | Count | Frequency (%) |
| 168960 | ||
| 3 | 106736 | |
| 4 | 69967 | |
| 2 | 51383 | 10.6% |
| 5 | 22785 | 4.7% |
| 0 | 22008 | 4.5% |
| . | 19750 | 4.1% |
| 1 | 8319 | 1.7% |
| 6 | 7475 | 1.5% |
| 7 | 2707 | 0.6% |
| Other values (9) | 6884 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1177806 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 168960 | ||
| d | 165341 | |
| s | 151538 | |
| B | 149236 | |
| e | 134898 | |
| 3 | 106736 | |
| 4 | 69967 | |
| 2 | 51383 | 4.4% |
| b | 32131 | 2.7% |
| 5 | 22785 | 1.9% |
| Other values (46) | 124831 |
state
Categorical
| Distinct | 39 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| FL | |
|---|---|
| TX | |
| NY | |
| CA | |
| NC | |
| Other values (34) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NC |
|---|---|
| 2nd row | WA |
| 3rd row | CA |
| 4th row | TX |
| 5th row | FL |
Common Values
| Value | Count | Frequency (%) |
| FL | 115449 | |
| TX | 83786 | |
| NY | 24479 | 6.5% |
| CA | 23386 | 6.2% |
| NC | 21862 | 5.8% |
| TN | 18340 | 4.9% |
| WA | 13826 | 3.7% |
| OH | 12588 | 3.3% |
| IL | 8939 | 2.4% |
| NV | 8482 | 2.2% |
| Other values (29) | 46048 | 12.2% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| fl | 115450 | |
| tx | 83786 | |
| ny | 24479 | 6.5% |
| ca | 23386 | 6.2% |
| nc | 21862 | 5.8% |
| tn | 18340 | 4.9% |
| wa | 13826 | 3.7% |
| oh | 12588 | 3.3% |
| il | 8939 | 2.4% |
| nv | 8482 | 2.2% |
| Other values (28) | 46047 | 12.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 124389 | |
| F | 115450 | |
| T | 104327 | |
| X | 83786 | |
| N | 76927 | |
| C | 56354 | |
| A | 55386 | |
| Y | 24569 | 3.3% |
| O | 22698 | 3.0% |
| I | 18122 | 2.4% |
| Other values (16) | 72362 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 754369 | |
| Lowercase Letter | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 124389 | |
| F | 115450 | |
| T | 104327 | |
| X | 83786 | |
| N | 76927 | |
| C | 56354 | |
| A | 55386 | |
| Y | 24569 | 3.3% |
| O | 22698 | 3.0% |
| I | 18122 | 2.4% |
| Other values (15) | 72361 |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 754370 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 124389 | |
| F | 115450 | |
| T | 104327 | |
| X | 83786 | |
| N | 76927 | |
| C | 56354 | |
| A | 55386 | |
| Y | 24569 | 3.3% |
| O | 22698 | 3.0% |
| I | 18122 | 2.4% |
| Other values (16) | 72362 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 754370 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| L | 124389 | |
| F | 115450 | |
| T | 104327 | |
| X | 83786 | |
| N | 76927 | |
| C | 56354 | |
| A | 55386 | |
| Y | 24569 | 3.3% |
| O | 22698 | 3.0% |
| I | 18122 | 2.4% |
| Other values (16) | 72362 |
stories
Text
Missing 
| Distinct | 347 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 150716 |
| Missing (%) | 40.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 42 |
|---|---|
| Median length | 3 |
| Mean length | 2.852439 |
| Min length | 1 |
Unique
| Unique | 83 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 3.0 |
| 4th row | 2.0 |
| 5th row | One |
| Value | Count | Frequency (%) |
| 1.0 | 67454 | |
| 2.0 | 55283 | |
| 1 | 24830 | 10.5% |
| 2 | 20958 | 8.9% |
| 3.0 | 11275 | 4.8% |
| 0.0 | 7241 | 3.1% |
| one | 6367 | 2.7% |
| 3 | 5398 | 2.3% |
| story | 4718 | 2.0% |
| 0 | 4273 | 1.8% |
| Other values (266) | 28640 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 172813 | |
| . | 155919 | |
| 1 | 96437 | |
| 2 | 80167 | |
| 3 | 17634 | 2.7% |
| e | 14174 | 2.2% |
| o | 11316 | 1.8% |
| 9968 | 1.5% | |
| r | 8570 | 1.3% |
| t | 8164 | 1.3% |
| Other values (51) | 70827 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 378924 | |
| Other Punctuation | 157572 | |
| Lowercase Letter | 75369 | 11.7% |
| Uppercase Letter | 22948 | 3.6% |
| Space Separator | 9968 | 1.5% |
| Math Symbol | 886 | 0.1% |
| Dash Punctuation | 320 | < 0.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 14174 | |
| o | 11316 | |
| r | 8570 | |
| t | 8164 | |
| n | 8141 | |
| y | 5014 | 6.7% |
| i | 3360 | 4.5% |
| w | 3173 | 4.2% |
| l | 3047 | 4.0% |
| u | 1598 | 2.1% |
| Other values (13) | 8812 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 7070 | |
| S | 6408 | |
| T | 3933 | |
| L | 1815 | 7.9% |
| M | 1412 | 6.2% |
| B | 890 | 3.9% |
| R | 614 | 2.7% |
| C | 299 | 1.3% |
| A | 217 | 0.9% |
| F | 99 | 0.4% |
| Other values (10) | 191 | 0.8% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 172813 | |
| 1 | 96437 | |
| 2 | 80167 | |
| 3 | 17634 | 4.7% |
| 9 | 3512 | 0.9% |
| 4 | 3464 | 0.9% |
| 5 | 2539 | 0.7% |
| 6 | 1251 | 0.3% |
| 7 | 639 | 0.2% |
| 8 | 468 | 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 155919 | |
| / | 980 | 0.6% |
| , | 673 | 0.4% |
Space Separator
| Value | Count | Frequency (%) |
| 9968 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 886 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 320 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 547672 | |
| Latin | 98317 | 15.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 14174 | |
| o | 11316 | |
| r | 8570 | 8.7% |
| t | 8164 | 8.3% |
| n | 8141 | 8.3% |
| O | 7070 | 7.2% |
| S | 6408 | 6.5% |
| y | 5014 | 5.1% |
| T | 3933 | 4.0% |
| i | 3360 | 3.4% |
| Other values (33) | 22167 |
Common
| Value | Count | Frequency (%) |
| 0 | 172813 | |
| . | 155919 | |
| 1 | 96437 | |
| 2 | 80167 | |
| 3 | 17634 | 3.2% |
| 9968 | 1.8% | |
| 9 | 3512 | 0.6% |
| 4 | 3464 | 0.6% |
| 5 | 2539 | 0.5% |
| 6 | 1251 | 0.2% |
| Other values (8) | 3968 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 645989 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 172813 | |
| . | 155919 | |
| 1 | 96437 | |
| 2 | 80167 | |
| 3 | 17634 | 2.7% |
| e | 14174 | 2.2% |
| o | 11316 | 1.8% |
| 9968 | 1.5% | |
| r | 8570 | 1.3% |
| t | 8164 | 1.3% |
| Other values (51) | 70827 |
mls-id
Text
Missing 
| Distinct | 24907 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 352243 |
| Missing (%) | 93.4% |
| Memory size | 2.9 MiB |
Length
| Max length | 24 |
|---|---|
| Median length | 12 |
| Mean length | 7.8794002 |
| Min length | 1 |
Unique
| Unique | 24874 ? |
|---|---|
| Unique (%) | 99.7% |
Sample
| 1st row | 19221142 |
|---|---|
| 2nd row | SR19195113 |
| 3rd row | 201909438 |
| 4th row | T3159863 |
| 5th row | T3204536 |
| Value | Count | Frequency (%) |
| no | 8 | < 0.1% |
| mls | 5 | < 0.1% |
| 983469 | 2 | < 0.1% |
| 241766 | 2 | < 0.1% |
| 201906177 | 2 | < 0.1% |
| 74184012 | 2 | < 0.1% |
| 1020414 | 2 | < 0.1% |
| 19-5064 | 2 | < 0.1% |
| 201909981 | 2 | < 0.1% |
| 617190 | 2 | < 0.1% |
| Other values (24897) | 24922 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 31390 | |
| 0 | 22606 | |
| 2 | 21470 | |
| 9 | 18569 | |
| 4 | 17233 | |
| 5 | 15664 | |
| 6 | 14750 | |
| 3 | 14566 | |
| 7 | 14516 | |
| 8 | 14386 | |
| Other values (47) | 11378 | 5.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 185150 | |
| Uppercase Letter | 10666 | 5.4% |
| Dash Punctuation | 643 | 0.3% |
| Lowercase Letter | 50 | < 0.1% |
| Space Separator | 12 | < 0.1% |
| Other Punctuation | 7 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2251 | |
| C | 1139 | |
| D | 811 | 7.6% |
| F | 668 | 6.3% |
| P | 612 | 5.7% |
| R | 600 | 5.6% |
| T | 551 | 5.2% |
| S | 539 | 5.1% |
| U | 506 | 4.7% |
| O | 413 | 3.9% |
| Other values (16) | 2576 |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 8 | |
| e | 5 | |
| d | 5 | |
| s | 4 | 8.0% |
| f | 4 | 8.0% |
| c | 4 | 8.0% |
| w | 3 | 6.0% |
| a | 3 | 6.0% |
| t | 2 | 4.0% |
| b | 2 | 4.0% |
| Other values (7) | 10 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 31390 | |
| 0 | 22606 | |
| 2 | 21470 | |
| 9 | 18569 | |
| 4 | 17233 | |
| 5 | 15664 | |
| 6 | 14750 | |
| 3 | 14566 | |
| 7 | 14516 | |
| 8 | 14386 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 4 | |
| # | 3 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 643 |
Space Separator
| Value | Count | Frequency (%) |
| 12 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 185812 | |
| Latin | 10716 | 5.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 2251 | |
| C | 1139 | |
| D | 811 | 7.6% |
| F | 668 | 6.2% |
| P | 612 | 5.7% |
| R | 600 | 5.6% |
| T | 551 | 5.1% |
| S | 539 | 5.0% |
| U | 506 | 4.7% |
| O | 413 | 3.9% |
| Other values (33) | 2626 |
Common
| Value | Count | Frequency (%) |
| 1 | 31390 | |
| 0 | 22606 | |
| 2 | 21470 | |
| 9 | 18569 | |
| 4 | 17233 | |
| 5 | 15664 | |
| 6 | 14750 | |
| 3 | 14566 | |
| 7 | 14516 | |
| 8 | 14386 | |
| Other values (4) | 662 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 196528 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 31390 | |
| 0 | 22606 | |
| 2 | 21470 | |
| 9 | 18569 | |
| 4 | 17233 | |
| 5 | 15664 | |
| 6 | 14750 | |
| 3 | 14566 | |
| 7 | 14516 | |
| 8 | 14386 | |
| Other values (47) | 11378 | 5.8% |
PrivatePool
Boolean
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 336874 |
| Missing (%) | 89.3% |
| Memory size | 736.8 KiB |
| True | |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| True | 40311 | 10.7% |
| (Missing) | 336874 |
MlsId
Text
Missing 
| Distinct | 232944 |
|---|---|
| Distinct (%) | 75.1% |
| Missing | 66880 |
| Missing (%) | 17.7% |
| Memory size | 2.9 MiB |
Length
| Max length | 60 |
|---|---|
| Median length | 58 |
| Mean length | 8.0889576 |
| Min length | 1 |
Unique
| Unique | 171673 ? |
|---|---|
| Unique (%) | 55.3% |
Sample
| 1st row | 611019 |
|---|---|
| 2nd row | 201916904 |
| 3rd row | FR19221027 |
| 4th row | 14191809 |
| 5th row | 861745 |
| Value | Count | Frequency (%) |
| fl | 2265 | 0.7% |
| miami | 884 | 0.3% |
| tx | 772 | 0.2% |
| beach | 351 | 0.1% |
| houston | 332 | 0.1% |
| orlando | 302 | 0.1% |
| lauderdale | 246 | 0.1% |
| fort | 241 | 0.1% |
| ca | 213 | 0.1% |
| austin | 206 | 0.1% |
| Other values (232028) | 319295 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 359697 | |
| 0 | 275829 | |
| 2 | 243681 | |
| 4 | 222316 | |
| 5 | 215575 | |
| 3 | 197981 | |
| 9 | 194840 | |
| 7 | 194113 | |
| 6 | 193488 | |
| 8 | 187133 | |
| Other values (66) | 225391 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2284653 | |
| Uppercase Letter | 160344 | 6.4% |
| Lowercase Letter | 32330 | 1.3% |
| Space Separator | 18956 | 0.8% |
| Other Punctuation | 8830 | 0.4% |
| Dash Punctuation | 4918 | 0.2% |
| Currency Symbol | 4 | < 0.1% |
| Open Punctuation | 2 | < 0.1% |
| Close Punctuation | 2 | < 0.1% |
| Modifier Symbol | 2 | < 0.1% |
| Other values (2) | 3 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 37284 | |
| C | 17144 | |
| D | 12958 | 8.1% |
| O | 11635 | 7.3% |
| P | 11002 | 6.9% |
| F | 9517 | 5.9% |
| T | 7678 | 4.8% |
| S | 6952 | 4.3% |
| R | 6579 | 4.1% |
| H | 6387 | 4.0% |
| Other values (16) | 33208 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4653 | |
| i | 3275 | |
| o | 3169 | |
| n | 2792 | |
| e | 2734 | |
| t | 2299 | 7.1% |
| r | 2128 | 6.6% |
| l | 2103 | 6.5% |
| s | 1808 | 5.6% |
| d | 1250 | 3.9% |
| Other values (13) | 6119 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 359697 | |
| 0 | 275829 | |
| 2 | 243681 | |
| 4 | 222316 | |
| 5 | 215575 | |
| 3 | 197981 | |
| 9 | 194840 | |
| 7 | 194113 | |
| 6 | 193488 | |
| 8 | 187133 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 8669 | |
| / | 49 | 0.6% |
| : | 47 | 0.5% |
| * | 26 | 0.3% |
| # | 18 | 0.2% |
| . | 11 | 0.1% |
| & | 7 | 0.1% |
| ! | 2 | < 0.1% |
| ; | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 18956 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4918 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 4 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 2 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 2 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2317370 | |
| Latin | 192674 | 7.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 37284 | |
| C | 17144 | 8.9% |
| D | 12958 | 6.7% |
| O | 11635 | 6.0% |
| P | 11002 | 5.7% |
| F | 9517 | 4.9% |
| T | 7678 | 4.0% |
| S | 6952 | 3.6% |
| R | 6579 | 3.4% |
| H | 6387 | 3.3% |
| Other values (39) | 65538 |
Common
| Value | Count | Frequency (%) |
| 1 | 359697 | |
| 0 | 275829 | |
| 2 | 243681 | |
| 4 | 222316 | |
| 5 | 215575 | |
| 3 | 197981 | |
| 9 | 194840 | |
| 7 | 194113 | |
| 6 | 193488 | |
| 8 | 187133 | |
| Other values (17) | 32717 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2510044 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 359697 | |
| 0 | 275829 | |
| 2 | 243681 | |
| 4 | 222316 | |
| 5 | 215575 | |
| 3 | 197981 | |
| 9 | 194840 | |
| 7 | 194113 | |
| 6 | 193488 | |
| 8 | 187133 | |
| Other values (66) | 225391 |
target
Text
| Distinct | 43939 |
|---|---|
| Distinct (%) | 11.7% |
| Missing | 2481 |
| Missing (%) | 0.7% |
| Memory size | 2.9 MiB |
Length
| Max length | 18 |
|---|---|
| Median length | 8 |
| Mean length | 7.9461522 |
| Min length | 1 |
Unique
| Unique | 29774 ? |
|---|---|
| Unique (%) | 7.9% |
Sample
| 1st row | $418,000 |
|---|---|
| 2nd row | $310,000 |
| 3rd row | $2,895,000 |
| 4th row | $2,395,000 |
| 5th row | $5,000 |
| Value | Count | Frequency (%) |
| 225,000 | 1806 | 0.5% |
| 275,000 | 1650 | 0.4% |
| 250,000 | 1644 | 0.4% |
| 350,000 | 1641 | 0.4% |
| 325,000 | 1562 | 0.4% |
| 399,000 | 1547 | 0.4% |
| 299,900 | 1534 | 0.4% |
| 249,900 | 1500 | 0.4% |
| 299,000 | 1452 | 0.4% |
| 375,000 | 1442 | 0.4% |
| Other values (34326) | 358928 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 984828 | |
| , | 418551 | |
| 9 | 332567 | 11.2% |
| $ | 308823 | 10.4% |
| 5 | 183665 | 6.2% |
| 2 | 147747 | 5.0% |
| 1 | 138827 | 4.7% |
| 4 | 121560 | 4.1% |
| 3 | 110323 | 3.7% |
| 7 | 77982 | 2.6% |
| Other values (8) | 152582 | 5.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2241621 | |
| Other Punctuation | 418949 | 14.1% |
| Currency Symbol | 308823 | 10.4% |
| Math Symbol | 7263 | 0.2% |
| Lowercase Letter | 796 | < 0.1% |
| Space Separator | 2 | < 0.1% |
| Dash Punctuation | 1 | < 0.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 984828 | |
| 9 | 332567 | 14.8% |
| 5 | 183665 | 8.2% |
| 2 | 147747 | 6.6% |
| 1 | 138827 | 6.2% |
| 4 | 121560 | 5.4% |
| 3 | 110323 | 4.9% |
| 7 | 77982 | 3.5% |
| 8 | 75823 | 3.4% |
| 6 | 68299 | 3.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 418551 | |
| / | 398 | 0.1% |
Lowercase Letter
| Value | Count | Frequency (%) |
| m | 398 | |
| o | 398 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 308823 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 7263 |
Space Separator
| Value | Count | Frequency (%) |
| 2 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2976659 | |
| Latin | 796 | < 0.1% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 984828 | |
| , | 418551 | |
| 9 | 332567 | 11.2% |
| $ | 308823 | 10.4% |
| 5 | 183665 | 6.2% |
| 2 | 147747 | 5.0% |
| 1 | 138827 | 4.7% |
| 4 | 121560 | 4.1% |
| 3 | 110323 | 3.7% |
| 7 | 77982 | 2.6% |
| Other values (6) | 151786 | 5.1% |
Latin
| Value | Count | Frequency (%) |
| m | 398 | |
| o | 398 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2977455 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 984828 | |
| , | 418551 | |
| 9 | 332567 | 11.2% |
| $ | 308823 | 10.4% |
| 5 | 183665 | 6.2% |
| 2 | 147747 | 5.0% |
| 1 | 138827 | 4.7% |
| 4 | 121560 | 4.1% |
| 3 | 110323 | 3.7% |
| 7 | 77982 | 2.6% |
| Other values (8) | 152582 | 5.1% |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| status | private pool | propertyType | street | baths | homeFacts | fireplace | city | schools | sqft | zipcode | beds | state | stories | mls-id | PrivatePool | MlsId | target | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Active | NaN | Single Family Home | 240 Heather Ln | 3.5 | {'atAGlanceFacts': [{'factValue': '2019', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': 'Central A/C, Heat Pump', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': None, 'factLabel': 'lotsize'}, {'factValue': '$144', 'factLabel': 'Price/sqft'}]} | Gas Logs | Southern Pines | [{'rating': ['4', '4', '7', 'NR', '4', '7', 'NR', 'NR'], 'data': {'Distance': ['2.7 mi', '3.6 mi', '5.1 mi', '4.0 mi', '10.5 mi', '12.6 mi', '2.7 mi', '3.1 mi'], 'Grades': ['3–5', '6–8', '9–12', 'PK–2', '6–8', '9–12', 'PK–5', 'K–12']}, 'name': ['Southern Pines Elementary School', 'Southern Middle School', 'Pinecrest High School', 'Southern Pines Primary School', "Crain's Creek Middle School", 'Union Pines High School', 'Episcopal Day Private School', 'Calvary Christian Private School']}] | 2900 | 28387 | 4 | NC | NaN | NaN | NaN | 611019 | $418,000 |
| 1 | for sale | NaN | single-family home | 12911 E Heroy Ave | 3 Baths | {'atAGlanceFacts': [{'factValue': '2019', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '5828 sqft', 'factLabel': 'lotsize'}, {'factValue': '$159/sqft', 'factLabel': 'Price/sqft'}]} | NaN | Spokane Valley | [{'rating': ['4/10', 'None/10', '4/10'], 'data': {'Distance': ['1.65mi', '1.32mi', '1.01mi'], 'Grades': ['9-12', '3-8', 'PK-8']}, 'name': ['East Valley High School&Extension', 'Eastvalley Middle School', 'Trentwood Elementary School']}] | 1,947 sqft | 99216 | 3 Beds | WA | 2.0 | NaN | NaN | 201916904 | $310,000 |
| 2 | for sale | NaN | single-family home | 2005 Westridge Rd | 2 Baths | {'atAGlanceFacts': [{'factValue': '1961', 'factLabel': 'Year built'}, {'factValue': '1967', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced Air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'Attached Garage', 'factLabel': 'Parking'}, {'factValue': '8,626 sqft', 'factLabel': 'lotsize'}, {'factValue': '$965/sqft', 'factLabel': 'Price/sqft'}]} | yes | Los Angeles | [{'rating': ['8/10', '4/10', '8/10'], 'data': {'Distance': ['1.19mi', '2.06mi', '2.63mi'], 'Grades': ['6-8', 'K-5', '9-12']}, 'name': ['Paul Revere Middle School', 'Brentwood Science School', 'Palisades Charter High School']}] | 3,000 sqft | 90049 | 3 Beds | CA | 1.0 | NaN | yes | FR19221027 | $2,895,000 |
| 3 | for sale | NaN | single-family home | 4311 Livingston Ave | 8 Baths | {'atAGlanceFacts': [{'factValue': '2006', 'factLabel': 'Year built'}, {'factValue': '2006', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced Air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'Detached Garage', 'factLabel': 'Parking'}, {'factValue': '8,220 sqft', 'factLabel': 'lotsize'}, {'factValue': '$371/sqft', 'factLabel': 'Price/sqft'}]} | yes | Dallas | [{'rating': ['9/10', '9/10', '10/10', '9/10'], 'data': {'Distance': ['1.05mi', '0.1mi', '1.05mi', '0.81mi'], 'Grades': ['5-6', 'PK-4', '7-8', '9-12']}, 'name': ['Mcculloch Intermediate School', 'Bradfield Elementary School', 'Highland Park Middle School', 'Highland Park High School']}] | 6,457 sqft | 75205 | 5 Beds | TX | 3.0 | NaN | NaN | 14191809 | $2,395,000 |
| 4 | for sale | NaN | lot/land | 1524 Kiscoe St | NaN | {'atAGlanceFacts': [{'factValue': '', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '10,019 sqft', 'factLabel': 'lotsize'}, {'factValue': None, 'factLabel': 'Price/sqft'}]} | NaN | Palm Bay | [{'rating': ['4/10', '5/10', '5/10'], 'data': {'Distance': ['5.96mi', '3.25mi', '3.03mi'], 'Grades': ['7-8', '9-12', 'PK-6']}, 'name': ['Southwest Middle School', 'Bayside High School', 'Westside Elementary School']}] | NaN | 32908 | NaN | FL | NaN | NaN | NaN | 861745 | $5,000 |
| 5 | for sale | NaN | townhouse | 1624 S Newkirk St | NaN | {'atAGlanceFacts': [{'factValue': '1920', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced Air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '680 sqft', 'factLabel': 'lotsize'}, {'factValue': '$233/sqft', 'factLabel': 'Price/sqft'}]} | NaN | Philadelphia | [{'rating': [], 'data': {'Distance': [], 'Grades': []}, 'name': []}] | 897 sqft | 19145 | 2 Beds | PA | 2.0 | NaN | NaN | PAPH847006 | $209,000 |
| 6 | Active | NaN | Florida | 552 Casanova Ct | NaN | {'atAGlanceFacts': [{'factValue': '2006', 'factLabel': 'Year built'}, {'factValue': '2006', 'factLabel': 'Remodeled year'}, {'factValue': 'Electric, Heat Pump', 'factLabel': 'Heating'}, {'factValue': 'Central Air', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '4,996 Sq. Ft.', 'factLabel': 'lotsize'}, {'factValue': '$120 / Sq. Ft.', 'factLabel': 'Price/sqft'}]} | NaN | POINCIANA | [{'rating': ['3', '3', '1', 'NR'], 'data': {'Distance': ['0.8 mi', '8.3 mi', '4.2 mi', '2.0 mi'], 'Grades': ['Preschool to 4', 'Preschool to 12', '5 to 8', '1 to 12']}, 'name': ['Palmetto Elementary School', 'Haines City Senior High School', 'Lake Marion Creek Elementary School', 'Chosen Generation Christian Academy']}] | 1,507 | 34759 | NaN | FL | One | NaN | NaN | S5026943 | 181,500 |
| 7 | Active | NaN | NaN | 6094 Mingle Dr | NaN | {'atAGlanceFacts': [{'factValue': '1976', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '8,750 Sq. Ft.', 'factLabel': 'lotsize'}, {'factValue': '$57 / Sq. Ft.', 'factLabel': 'Price/sqft'}]} | NaN | Memphis | [{'rating': ['4', '2', '2'], 'data': {'Distance': ['0.7 mi', '0.4 mi', '2.2 mi'], 'Grades': ['Preschool to 5', '6 to 8', '9 to 12']}, 'name': ['Crump Elementary School', 'Hickory Ridge Middle School', 'Wooddale High School']}] | NaN | 38115 | NaN | TN | NaN | NaN | NaN | 10063506 | 68,000 |
| 8 | Active | NaN | Single Family Home | 11182 Owl Ave | 2 | {'atAGlanceFacts': [{'factValue': '1970', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced Air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '124582', 'factLabel': 'lotsize'}, {'factValue': '$68', 'factLabel': 'Price/sqft'}]} | NaN | Mason City | [{'rating': ['2', '2', '4', '7', '4', 'NR'], 'data': {'Distance': ['5.6 mi', '5.6 mi', '6.8 mi', '6.5 mi', '6.8 mi', '6.8 mi'], 'Grades': ['PK–4', '5–6', '9–12', 'PK–4', '7–8', '9–12']}, 'name': ['Roosevelt Elementary School', 'Lincoln Intermediate School', 'Mason City High School', 'Jefferson Elementary School', 'John Adams Middle School', 'Alternative School']}] | 3588 | 50401 | 3 | IA | NaN | NaN | NaN | 190988 | $244,900 |
| 9 | NaN | NaN | Single Family | 8612 Cedar Plains Ln | 3 | {'atAGlanceFacts': [{'factValue': '2019', 'factLabel': 'Year built'}, {'factValue': None, 'factLabel': 'Remodeled year'}, {'factValue': 'Gas', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'Attached Garage', 'factLabel': 'Parking'}, {'factValue': '2,056 sqft', 'factLabel': 'lotsize'}, {'factValue': '$162', 'factLabel': 'Price/sqft'}]} | NaN | Houston | [{'rating': ['4/10', '3/10', '2/10'], 'data': {'Distance': ['0.7 mi', '0.6 mi', '1.9 mi'], 'Grades': ['PK-5', '5-8', '9-12']}, 'name': ['Edgewood Elementary School', 'Landrum Middle School', 'Northbrook High School']}] | 1,930 | 77080 | 3 | TX | 2.0 | NaN | NaN | 73968331 | $311,995 |
| status | private pool | propertyType | street | baths | homeFacts | fireplace | city | schools | sqft | zipcode | beds | state | stories | mls-id | PrivatePool | MlsId | target | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 377175 | for sale | NaN | single-family home | 9711 Lawngate Dr | 3 Baths | {'atAGlanceFacts': [{'factValue': '1970', 'factLabel': 'Year built'}, {'factValue': '1970', 'factLabel': 'Remodeled year'}, {'factValue': 'Other', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'Detached Garage', 'factLabel': 'Parking'}, {'factValue': '6,599 sqft', 'factLabel': 'lotsize'}, {'factValue': '$156/sqft', 'factLabel': 'Price/sqft'}]} | yes | Houston | [{'rating': ['2/10', '3/10', '3/10'], 'data': {'Distance': ['0.65mi', '1.15mi', '0.19mi'], 'Grades': ['9-12', 'PK-5', '6-8']}, 'name': ['Northbrook High School', 'Terrace Elementary School', 'Northbrook Middle School']}] | 1,792 sqft | 77080 | 4 Beds | TX | 2.0 | NaN | NaN | 74136719 | $280,000 |
| 377176 | NaN | NaN | Single Family | 3263 Wolcott Pl | 2.0 | {'atAGlanceFacts': [{'factValue': '1962', 'factLabel': 'Year built'}, {'factValue': '1967', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '1 space', 'factLabel': 'Parking'}, {'factValue': '7,704 sqft', 'factLabel': 'lotsize'}, {'factValue': None, 'factLabel': 'Price/sqft'}]} | Yes | Orlando | [{'rating': ['3/10', '1/10', '3/10'], 'data': {'Distance': ['1.5 mi', '1.3 mi', '1.1 mi'], 'Grades': ['PK-5', '6-8', '9-12']}, 'name': ['Washington Shores Elementary School', 'Carver Middle School', 'Jones High School']}] | 1,829 sqft | 32805 | 3 | FL | 1 | NaN | NaN | NaN | $171,306 |
| 377177 | Active | NaN | Single Detached, Traditional | 2805 S Jennings Ave | NaN | {'atAGlanceFacts': [{'factValue': '1921', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': 'Central A/C (Electric), Central Heat (Electric)', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '7,500 Sq. Ft.', 'factLabel': 'lotsize'}, {'factValue': '$105 / Sq. Ft.', 'factLabel': 'Price/sqft'}]} | NaN | Fort Worth | [{'rating': ['4', '6', '5'], 'data': {'Distance': ['0.5 mi', '2.0 mi', '1.3 mi'], 'Grades': ['Preschool to 5', '6 to 8', '9 to 12']}, 'name': ['Daggett Elementary School', 'Rosemont Middle School', 'Paschal High School']}] | 1,895 | 76110 | NaN | TX | NaN | NaN | NaN | 14087883 | 199,900 |
| 377178 | NaN | NaN | Single Family | Buildable plan: The Torino (384L) Riverstone Ranch - Premier | 2 | {'atAGlanceFacts': [{'factValue': '2019', 'factLabel': 'Year built'}, {'factValue': None, 'factLabel': 'Remodeled year'}, {'factValue': 'No Data', 'factLabel': 'Heating'}, {'factValue': 'No Data', 'factLabel': 'Cooling'}, {'factValue': '2 spaces', 'factLabel': 'Parking'}, {'factValue': 'No Data', 'factLabel': 'lotsize'}, {'factValue': '$137', 'factLabel': 'Price/sqft'}]} | NaN | Houston | [{'rating': ['7/10', '6/10', '5/10'], 'data': {'Distance': ['0.3 mi', '2.5 mi', '2.5 mi'], 'Grades': ['PK-4', '7-8', '9-12']}, 'name': ['South Belt Elementary School', 'Thompson Intermediate School', 'Dobie High School']}] | 1,841 | 77089 | 4 | TX | 1.0 | NaN | NaN | NaN | $252,990 |
| 377179 | For sale | NaN | Condo | 2238 11th St NW APT 2 | 3 | {'atAGlanceFacts': [{'factValue': '2010', 'factLabel': 'Year built'}, {'factValue': None, 'factLabel': 'Remodeled year'}, {'factValue': 'Forced air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '1 space', 'factLabel': 'Parking'}, {'factValue': None, 'factLabel': 'lotsize'}, {'factValue': '$564', 'factLabel': 'Price/sqft'}]} | NaN | Washington | [{'rating': ['3/10', '3/10'], 'data': {'Distance': ['0.4 mi', '0.1 mi'], 'Grades': ['PK-5', '6-12']}, 'name': ['Garrison Elementary School', 'Cardozo Education Campus']}] | 1,417 | 20001 | 2 | DC | 3.0 | NaN | NaN | DCDC444306 | $799,000 |
| 377180 | NaN | NaN | Single Family | 20800 NE 23rd Ave | 6.0 | {'atAGlanceFacts': [{'factValue': '1990', 'factLabel': 'Year built'}, {'factValue': '1990', 'factLabel': 'Remodeled year'}, {'factValue': 'Other', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '2 spaces', 'factLabel': 'Parking'}, {'factValue': '8,500 sqft', 'factLabel': 'lotsize'}, {'factValue': '$311', 'factLabel': 'Price/sqft'}]} | NaN | Miami | [{'rating': ['10/10', '5/10'], 'data': {'Distance': ['32.1 mi', '1.1 mi'], 'Grades': ['PK-8', '9-12']}, 'name': ['Air Base Elementary School', 'Dr Michael M. Krop Senior High School']}] | 4,017 | 33180 | 5 | FL | 0.0 | NaN | Yes | A10702700 | $1,249,000 |
| 377181 | for sale | NaN | condo | 3530 N Lake Shore Dr #4B | 3 Baths | {'atAGlanceFacts': [{'factValue': '1924', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': 'Radiant', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': 'None', 'factLabel': 'Parking'}, {'factValue': '', 'factLabel': 'lotsize'}, {'factValue': '$337/sqft', 'factLabel': 'Price/sqft'}]} | NaN | Chicago | [{'rating': ['1/10', '5/10', '7/10'], 'data': {'Distance': ['10.61mi', '1.42mi', '0.4mi'], 'Grades': ['9-12', '9-12', 'PK-8']}, 'name': ['Hope College Prep High School', 'Lake View High School', 'Nettelhorst Elementary School']}] | 2,000 sqft | 60657 | 3 Beds | IL | 9.0 | NaN | NaN | 10374233 | $674,999 |
| 377182 | for sale | NaN | single-family home | 15509 Linden Blvd | 3 Baths | {'atAGlanceFacts': [{'factValue': '1950', 'factLabel': 'Year built'}, {'factValue': '1950', 'factLabel': 'Remodeled year'}, {'factValue': 'Other', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '2', 'factLabel': 'Parking'}, {'factValue': '1,600 sqft', 'factLabel': 'lotsize'}, {'factValue': '$458/sqft', 'factLabel': 'Price/sqft'}]} | NaN | Jamaica | [{'rating': ['5/10', '4/10'], 'data': {'Distance': ['0.48mi', '0.73mi'], 'Grades': ['PK-5', '6-8']}, 'name': ['Ps 48 William Wordsworth', 'Jhs 8 Richard S Grossley']}] | 1,152 sqft | 11434 | 3 Beds | NY | 2 | NaN | NaN | NaN | $528,000 |
| 377183 | NaN | NaN | NaN | 7810 Pereida St | NaN | {'atAGlanceFacts': [{'factValue': None, 'factLabel': 'Year built'}, {'factValue': None, 'factLabel': 'Remodeled year'}, {'factValue': None, 'factLabel': 'Heating'}, {'factValue': None, 'factLabel': 'Cooling'}, {'factValue': None, 'factLabel': 'Parking'}, {'factValue': None, 'factLabel': 'lotsize'}, {'factValue': None, 'factLabel': 'Price/sqft'}]} | NaN | Houston | [{'rating': ['NA', 'NA', 'NA'], 'data': {'Distance': ['1.3 mi', '0.5 mi', '1.9 mi'], 'Grades': ['PK-5', '6-8', '9-12']}, 'name': ['Hiliard El', 'Forest Brook Middle', 'North Forest High School']}] | NaN | 77028 | 8,479 sqft | TX | NaN | NaN | NaN | NaN | $34,500 |
| 377184 | NaN | NaN | Single Family | 5983 Midcrown Dr | 2.0 | {'atAGlanceFacts': [{'factValue': '2019', 'factLabel': 'Year built'}, {'factValue': None, 'factLabel': 'Remodeled year'}, {'factValue': 'Electric', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'No Data', 'factLabel': 'Parking'}, {'factValue': '6,969 sqft', 'factLabel': 'lotsize'}, {'factValue': '$140', 'factLabel': 'Price/sqft'}]} | Not Applicable | San Antonio | [{'rating': ['5/10', '4/10', '3/10'], 'data': {'Distance': ['0.3 mi', '1.1 mi', '4.1 mi'], 'Grades': ['PK-5', '6-8', '9-12']}, 'name': ['Mary Lou Hartman', 'Woodlake Hills Middle School', 'Judson High School']}] | 1,462 | 78218 | 3 | TX | 1.0 | NaN | NaN | 1403619 | $204,900 |
Duplicate rows
Most frequently occurring
| status | private pool | propertyType | street | baths | homeFacts | fireplace | city | schools | sqft | zipcode | beds | state | stories | mls-id | PrivatePool | MlsId | target | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46 | for sale | NaN | townhouse | The Lockland 27-33 Plan in Landen Pine | 3.5 Baths | {'atAGlanceFacts': [{'factValue': '', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '', 'factLabel': 'lotsize'}, {'factValue': '$299/sqft', 'factLabel': 'Price/sqft'}]} | NaN | Atlanta | [{'rating': ['6/10', '6/10', '6/10'], 'data': {'Distance': ['3.85mi', '0.65mi', '1.88mi'], 'Grades': ['10-12', 'PK-5', '6-8']}, 'name': ['North Atlanta High School', 'Smith Elementary School', 'Sutton Middle School']}] | 2,806 sqft | 30305 | 4 Beds | GA | NaN | NaN | NaN | NaN | $839,900+ | 3 |
| 0 | For sale | NaN | Single Family | 11207 NE 127th Ave | 2.0 | {'atAGlanceFacts': [{'factValue': '2015', 'factLabel': 'Year built'}, {'factValue': '2015', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '2 spaces', 'factLabel': 'Parking'}, {'factValue': '5,662 sqft', 'factLabel': 'lotsize'}, {'factValue': '$246', 'factLabel': 'Price/sqft'}]} | NaN | Vancouver | [{'rating': ['4/10', '4/10', '6/10'], 'data': {'Distance': ['2.1 mi', '2.1 mi', '0.8 mi'], 'Grades': ['PK-4', '5-8', '9-12']}, 'name': ['Glenwood Heights Primary School', 'Laurin Middle School', 'Prairie High School']}] | 1,670 | 98682 | 3 | WA | 1 | NaN | NaN | 19047778 | $410,000 | 2 |
| 1 | New construction | NaN | Multi Family | 335 H St NE | NaN | {'atAGlanceFacts': [{'factValue': '2017', 'factLabel': 'Year built'}, {'factValue': None, 'factLabel': 'Remodeled year'}, {'factValue': 'Forced air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'No Data', 'factLabel': 'Parking'}, {'factValue': None, 'factLabel': 'lotsize'}, {'factValue': '$651', 'factLabel': 'Price/sqft'}]} | NaN | Washington | [{'rating': ['8/10', '6/10', '4/10'], 'data': {'Distance': ['0.2 mi', '0.2 mi', '1.5 mi'], 'Grades': ['PK-5', '6-8', '9-12']}, 'name': ['Ludlow-Taylor Elementary School', 'Stuart-Hobson Middle School', 'Eastern High School']}] | 3,600 sqft | 20002 | 0 | DC | 4 | NaN | NaN | 1000123741 | $2,345,000 | 2 |
| 2 | for sale | NaN | apartment | 269 W 87th St #B | 6 Baths | {'atAGlanceFacts': [{'factValue': '2018', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '', 'factLabel': 'lotsize'}, {'factValue': '$2,447/sqft', 'factLabel': 'Price/sqft'}]} | NaN | New York | [{'rating': ['8/10'], 'data': {'Distance': ['0.23mi'], 'Grades': ['K-5']}, 'name': ['Ps 166 The Richard Rogers School Of The Arts And S']}] | 3,882 sqft | 10024 | 5 Beds | NY | NaN | NaN | NaN | 1245762 | $9,500,000 | 2 |
| 3 | for sale | NaN | condo | 1517 Briarcliff Rd NE #C | 3 Baths | {'atAGlanceFacts': [{'factValue': '2018', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced Air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'Attached Garage', 'factLabel': 'Parking'}, {'factValue': '', 'factLabel': 'lotsize'}, {'factValue': '$368/sqft', 'factLabel': 'Price/sqft'}]} | NaN | Atlanta | [{'rating': ['5/10', '5/10', '6/10'], 'data': {'Distance': ['1.02mi', '1.11mi', '3.91mi'], 'Grades': ['PK-5', '9-12', '6-8']}, 'name': ['Briar Vista Elementary School', 'Druid Hills High School', 'Druid Hills Middle School']}] | 2,386 sqft | 30306 | 2 Beds | GA | NaN | NaN | NaN | 6126572 | $877,860 | 2 |
| 4 | for sale | NaN | condo | 184 Kent Ave #A314 | NaN | {'atAGlanceFacts': [{'factValue': '1915', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '', 'factLabel': 'lotsize'}, {'factValue': '$1,369/sqft', 'factLabel': 'Price/sqft'}]} | NaN | Brooklyn | [{'rating': ['6/10'], 'data': {'Distance': ['0.5mi'], 'Grades': ['PK-5']}, 'name': ['Ps 17 Henry D Woodworth']}] | 712 sqft | 11249 | NaN | NY | NaN | NaN | NaN | 1123517 | $975,000 | 2 |
| 5 | for sale | NaN | condo | 184 Kent Ave #B301 | 2 Baths | {'atAGlanceFacts': [{'factValue': '1915', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '', 'factLabel': 'lotsize'}, {'factValue': '$1,855/sqft', 'factLabel': 'Price/sqft'}]} | NaN | Brooklyn | [{'rating': ['6/10'], 'data': {'Distance': ['0.47mi'], 'Grades': ['PK-5']}, 'name': ['Ps 17 Henry D Woodworth']}] | 1,078 sqft | 11249 | 2 Beds | NY | NaN | NaN | NaN | 1062169 | $2,000,000 | 2 |
| 6 | for sale | NaN | condo | 519 Circle St #A | 4 Baths | {'atAGlanceFacts': [{'factValue': '2007', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': 'Forced Air', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': 'Attached Garage', 'factLabel': 'Parking'}, {'factValue': '9,714 sqft', 'factLabel': 'lotsize'}, {'factValue': '$192/sqft', 'factLabel': 'Price/sqft'}]} | yes | Alamo Heights | [{'rating': ['7/10', '7/10', '6/10'], 'data': {'Distance': ['0.75mi', '1.45mi', '0.12mi'], 'Grades': ['9-12', '6-8', '1-5']}, 'name': ['Alamo Heights High School', 'Alamo Heights J High School', 'Cambridge Elementary School']}] | 3,385 sqft | 78209 | 4 Beds | TX | NaN | NaN | NaN | 1363375 | $650,000 | 2 |
| 7 | for sale | NaN | coop | 152 W 58th St #1 | 2 Baths | {'atAGlanceFacts': [{'factValue': '1916', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': 'Central', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '', 'factLabel': 'lotsize'}, {'factValue': None, 'factLabel': 'Price/sqft'}]} | yes | New York | [{'rating': ['9/10', '8/10', '3/10', '8/10', '9/10', '5/10'], 'data': {'Distance': ['2.02mi', '2.02mi', '2.1mi', '2.16mi', '4.52mi', '0.58mi'], 'Grades': ['6-8', '9-12', '6-12', '6-11', '6-8', 'PK-5']}, 'name': ['Nyc Lab Ms For Collaborative Studies', 'Nyc Lab High School For Collaborative Studies', 'Life Sciences Secondary School', 'Ms 260 Clinton School Writers And Artists', 'Lower Manhattan Community Middle School', 'Ps 111 Adolph S Ochs']}] | NaN | 10019 | 3 Beds | NY | NaN | NaN | NaN | 1230018 | $2,500,000 | 2 |
| 8 | for sale | NaN | lot/land | 116 Country Club Rd | NaN | {'atAGlanceFacts': [{'factValue': '', 'factLabel': 'Year built'}, {'factValue': '', 'factLabel': 'Remodeled year'}, {'factValue': '', 'factLabel': 'Heating'}, {'factValue': '', 'factLabel': 'Cooling'}, {'factValue': '', 'factLabel': 'Parking'}, {'factValue': '7840 sqft', 'factLabel': 'lotsize'}, {'factValue': None, 'factLabel': 'Price/sqft'}]} | NaN | Asheville | [{'rating': ['8/10', '5/10', '5/10', '7/10', '4/10', '6/10', '4/10', '6/10'], 'data': {'Distance': ['3.34mi', '1.98mi', '3.34mi', '3.51mi', '0.95mi', '0.63mi', '2.46mi', '4.23mi'], 'Grades': ['9-12', 'PK-5', '9-12', 'PK-5', 'K-5', 'PK-5', '6-8', 'K-5']}, 'name': ['School Of Inquiry And Life Science', 'Isaac Dickson Elementary', 'Asheville High', 'Hall Fletcher Elementary', 'Claxton Elementary', 'Ira B Jones Elementary', 'Asheville Middle', 'Vance Elementary']}] | NaN | 28804 | NaN | NC | NaN | NaN | NaN | 3462298 | $169,900 | 2 |